Trim Function

Returns the String passed with leading and trailing whitespaces removed.

Syntax

result = Trim( SourceString )

result = Trim


Parameters

SourceString

String

The source, a copy of which, to be returned with leading and trailing whitespaces removed.

stringVariable.Trim


Notes

Trim uses the list of unicode "whitespace" characters at http://www.unicode.org/Public/UNIDATA/UCD.html#White_Space.


Examples

This example removes the whitespaces from either side of the string passed:

Dim s as String
s=Trim("  Hello World  ") //Returns "Hello World"

See Also

Asc, Chr, InStr, Left, Len, LTrim, Mid, Right, RTrim functions.